<?php
$strTableName="brcs_report";
$_SESSION["OwnerID"] = $_SESSION["_".$strTableName."_OwnerID"];

$strOriginalTableName="brcs";

$gstrOrderBy="";
if(strlen($gstrOrderBy) && strtolower(substr($gstrOrderBy,0,8))!="order by")
	$gstrOrderBy="order by ".$gstrOrderBy;

$g_orderindexes=array();
$gsqlHead="SELECT brcs.id,  brcs.bank_id,  brcs.account_id,  brcs.ra_id,  brcs.signature,  brcs.designation,  brcs.office_address,  brcs.residential_address,  brcs.place,  brcs.brc_date,  brc_items.invoice_no,  brc_items.invoice_date,  brc_items.custom_no,  brc_items.custom_date,  brc_items.description,  brc_items.blrawb_no,  brc_items.blrawb_date,  brc_items.country_id,  brc_items.bill_amount,  brc_items.currency_id,  brc_items.freight_amount,  brc_items.insurance_amount,  brc_items.freely_convertable,  brc_items.fob,  brc_items.realisation_date,  brc_items.sdf_form_no,  brc_items.remarks";
$gsqlFrom="FROM brcs  INNER JOIN brc_items ON brcs.id = brc_items.brc_id";
$gsqlWhereExpr="";
$gsqlTail="";

include(getabspath("include/brcs_report_settings.php"));

// alias for 'SQLQuery' object
$gQuery = &$queryData_brcs_report;
$eventObj = &$tableEvents["brcs_report"];

$reportCaseSensitiveGroupFields = false;

$gstrSQL = gSQLWhere("");


?>